/**
 * 
 */
package mdb.com.vn.persist;

import java.math.BigDecimal;
import java.util.List;

import mdb.com.vn.model.FixedDeposits;

/**
 * @author tu.dod
 *
 */
public interface FixedDepositsDAO extends AbstractDAO<FixedDeposits, Integer> {
	public List<FixedDeposits> getAllFixexDeposits();
	
	public List<FixedDeposits> findByPersionalType(int type);
	public List<FixedDeposits> findByCorporateType(int type);
	public List<FixedDeposits> findByCode(String code);
	public List<FixedDeposits> findByCustomerRef(String customerId);
	public int getSCardFDAvailable (String customerRef);
	public double getAmountCorpAvailable (String customerRef);
	public double getAmountCorpAvailableException (String customerRef,String accountException);
	public int getSCardFDAvailableException (String customerRef,String accountException);
	public int countThanksCasrd();
	public BigDecimal sumAmount();
	
}
